IF EXISTS (
       SELECT *
       FROM   sys.objects
       WHERE  OBJECT_ID = OBJECT_ID(N'[dbo].[cms_sp_MediaDelete]')
              AND TYPE IN (N'P' ,N'PC')
   )
    DROP PROCEDURE [dbo].[cms_sp_MediaDelete]
GO
CREATE PROCEDURE [dbo].[cms_sp_MediaDelete]
	@Id INT
AS
	DELETE 
	FROM   Media
	WHERE  MediaId = @Id
GO